<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" useStyleVersion="10">
				<modelPath>/content/folder[@name='Packages']/package[@name='Chargeback']/model[@name='model']</modelPath>
				<drillBehavior modelBasedDrillThru="true"/>
				
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:1500px"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;background-color:#6198C5;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Application Capacity Changes and Growth</staticValue></dataSource></textItem></contents><style><CSS value="height:36px;padding-left:10px;font-family:Arial;font-size:24px;color:#333333;background-color:#FBFBFB;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Application Inventory</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Monthly Differential)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px;padding-bottom:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><crosstab horizontalPagination="true" name="Crosstab1" refQuery="Application" rowsPerPage="5000">
			<crosstabCorner>
				<contents/>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="xm"/>
					</defaultStyles>
				<CSS value="vertical-align:middle;font-weight:bold;color:gray;font-size:14pt;text-align:left"/></style>
			</crosstabCorner>
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse"/>
				<defaultStyles>
					<defaultStyle refStyle="xt"/>
				</defaultStyles>
			</style>
		<crosstabFactCell><contents><textItem><dataSource><cellValue/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="mv"/></defaultStyles></style></crosstabFactCell><crosstabRows><crosstabNode><crosstabNodeMembers><crosstabSpacer edgeLocation="s4">
			<contents>
				<textItem>
					<dataSource>
						<staticValue> </staticValue>
					</dataSource>
				</textItem>
			<textItem><dataSource><staticValue>Application Name</staticValue></dataSource><style><CSS value="font-weight:bold;color:#7C7C7C"/></style></textItem></contents>
			
			<style>
				<defaultStyles>
					<defaultStyle refStyle="xs"/>
				</defaultStyles>
			</style>
		</crosstabSpacer></crosstabNodeMembers></crosstabNode><crosstabNode><crosstabNodeMembers><crosstabNodeMember edgeLocation="e1" refDataItem="Storage Name"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles><CSS value="background-color:white;color:black;font-weight:bold"/></style><contents><textItem><dataSource><memberCaption/></dataSource><style><CSS value="color:#454545"/></style></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabRows><crosstabColumns><crosstabNode><crosstabNestedNodes><crosstabNode><crosstabNodeMembers><crosstabNodeMember edgeLocation="e4" refDataItem="Beginning Used (TB)"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles><CSS value="font-weight:bold;color:rgb(227,228,227)"/></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabNestedNodes><crosstabNodeMembers><crosstabSpacer edgeLocation="s2">
			<contents>
				<textItem>
					<dataSource>
						<staticValue> </staticValue>
					</dataSource>
				</textItem>
			<textItem><dataSource><staticValue>Begin Used (TB)</staticValue></dataSource><style><CSS value="color:#7C7C7C"/></style></textItem></contents>
			
			<style>
				<defaultStyles>
					<defaultStyle refStyle="xs"/>
				</defaultStyles>
			<CSS value="color:black;font-weight:bold"/></style>
		</crosstabSpacer></crosstabNodeMembers></crosstabNode><crosstabNode><crosstabNestedNodes><crosstabNode><crosstabNodeMembers><crosstabNodeMember edgeLocation="e5" refDataItem="Current Used (TB)"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles><CSS value="font-weight:bold;color:rgb(227,228,227)"/></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabNestedNodes><crosstabNodeMembers><crosstabSpacer edgeLocation="s1">
			<contents>
				<textItem>
					<dataSource>
						<staticValue> </staticValue>
					</dataSource>
				</textItem>
			<textItem><dataSource><staticValue>Current Used (TB)</staticValue></dataSource><style><CSS value="color:#7C7C7C"/></style></textItem></contents>
			
			<style>
				<defaultStyles>
					<defaultStyle refStyle="xs"/>
				</defaultStyles>
			<CSS value="color:black;font-weight:bold"/></style>
		</crosstabSpacer></crosstabNodeMembers></crosstabNode><crosstabNode><crosstabNestedNodes><crosstabNode><crosstabNodeMembers><crosstabNodeMember edgeLocation="e2" refDataItem="Diff +/-"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles><CSS value="color:black;font-weight:bold"/></style><contents><textItem><dataSource><memberCaption/></dataSource><style><CSS value="color:#7C7C7C"/></style></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabNestedNodes><crosstabNodeMembers><crosstabNodeMember edgeLocation="e3" refDataItem="Full Date"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles><dataFormat><dateFormat showDays="false" showMonths="shortName" showYears="true"/></dataFormat><CSS value="color:black;font-weight:bold"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Full Date"/></dataSource><style><CSS value="color:#7C7C7C"/></style></textItem></contents><sortList><sortItem refDataItem="Full Date"/></sortList></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabColumns><crosstabIntersections><crosstabIntersection column="e4" row="e1"><style><CSS value="background-color:white;border:1pt solid silver"/></style></crosstabIntersection><crosstabIntersection column="e5" row="e1"><style><CSS value="background-color:white;border:1pt solid silver"/></style></crosstabIntersection><crosstabIntersection column="e2" row="e1"><style><CSS value="background-color:white;border:1pt solid silver"/><dataFormat><format pattern="####.##" whenAnyError="0" whenMissing="0" whenNotApplicable="0" whenSecurityError="0"/></dataFormat></style><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 2"/></conditionalStyleRefs></crosstabIntersection></crosstabIntersections><conditionalRender refVariable="hidePrimary"><renderFor refVariableValue="1"/></conditionalRender></crosstab></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><crosstab horizontalPagination="true" name="Crosstab2" refQuery="Application Summary" rowsPerPage="5000">
			<crosstabCorner>
				<contents/>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="xm"/>
					</defaultStyles>
				<CSS value="vertical-align:middle;font-weight:bold;color:gray;font-size:14pt;text-align:left"/></style>
			</crosstabCorner>
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse"/>
				<defaultStyles>
					<defaultStyle refStyle="xt"/>
				</defaultStyles>
			</style>
		<crosstabFactCell><contents><textItem><dataSource><cellValue/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="mv"/></defaultStyles></style></crosstabFactCell><crosstabRows><crosstabNode><crosstabNodeMembers><crosstabSpacer edgeLocation="s4">
			<contents>
				<textItem>
					<dataSource>
						<staticValue> </staticValue>
					</dataSource>
				</textItem>
			<textItem><dataSource><staticValue>Application Name</staticValue></dataSource><style><CSS value="font-weight:bold;color:#7C7C7C"/></style></textItem></contents>
			
			<style>
				<defaultStyles>
					<defaultStyle refStyle="xs"/>
				</defaultStyles>
			</style>
		</crosstabSpacer></crosstabNodeMembers></crosstabNode><crosstabNode><crosstabNodeMembers><crosstabNodeMember edgeLocation="e1" refDataItem="Storage Name"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles><CSS value="background-color:white;color:black;font-weight:bold"/></style><contents><textItem><dataSource><memberCaption/></dataSource><style><CSS value="color:#7C7C7C"/></style></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode><crosstabNode><crosstabNodeMembers><crosstabNodeMember refDataItem="Total(Storage Name)2" edgeLocation="e6"><style><defaultStyles><defaultStyle refStyle="ol"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Total(Storage Name)2"/></dataSource></textItem></contents><factCell><style><defaultStyles><defaultStyle refStyle="ov"/></defaultStyles></style></factCell></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabRows><crosstabColumns><crosstabNode><crosstabNestedNodes><crosstabNode><crosstabNodeMembers><crosstabNodeMember edgeLocation="e4" refDataItem="Beginning Used (TB)"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles><CSS value="font-weight:bold;color:rgb(227,228,227)"/></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabNestedNodes><crosstabNodeMembers><crosstabSpacer edgeLocation="s2">
			<contents>
				<textItem>
					<dataSource>
						<staticValue> </staticValue>
					</dataSource>
				</textItem>
			<textItem><dataSource><staticValue>Begin Used (TB)</staticValue></dataSource><style><CSS value="color:#7C7C7C"/></style></textItem></contents>
			
			<style>
				<defaultStyles>
					<defaultStyle refStyle="xs"/>
				</defaultStyles>
			<CSS value="color:black;font-weight:bold"/></style>
		</crosstabSpacer></crosstabNodeMembers></crosstabNode><crosstabNode><crosstabNestedNodes><crosstabNode><crosstabNodeMembers><crosstabNodeMember edgeLocation="e5" refDataItem="Current Used (TB)"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles><CSS value="font-weight:bold;color:rgb(227,228,227)"/></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabNestedNodes><crosstabNodeMembers><crosstabSpacer edgeLocation="s1">
			<contents>
				<textItem>
					<dataSource>
						<staticValue> </staticValue>
					</dataSource>
				</textItem>
			<textItem><dataSource><staticValue>Current Used (TB)</staticValue></dataSource><style><CSS value="color:#7C7C7C"/></style></textItem></contents>
			
			<style>
				<defaultStyles>
					<defaultStyle refStyle="xs"/>
				</defaultStyles>
			<CSS value="color:black;font-weight:bold"/></style>
		</crosstabSpacer></crosstabNodeMembers></crosstabNode><crosstabNode><crosstabNestedNodes><crosstabNode><crosstabNodeMembers><crosstabNodeMember edgeLocation="e2" refDataItem="Diff +/-"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles><CSS value="color:black;font-weight:bold"/></style><contents><textItem><dataSource><memberCaption/></dataSource><style><CSS value="color:#7C7C7C"/></style></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabNestedNodes><crosstabNodeMembers><crosstabNodeMember edgeLocation="e3" refDataItem="Full Date"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles><dataFormat><dateFormat showDays="false" showMonths="shortName" showYears="true"/></dataFormat><CSS value="color:black;font-weight:bold"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Full Date"/></dataSource><style><CSS value="color:#7C7C7C"/></style></textItem></contents><sortList><sortItem refDataItem="Full Date"/></sortList></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabColumns><crosstabIntersections><crosstabIntersection column="e4" row="e1"><style><CSS value="background-color:white;border:1pt solid silver"/></style></crosstabIntersection><crosstabIntersection column="e5" row="e1"><style><CSS value="background-color:white;border:1pt solid silver"/></style></crosstabIntersection><crosstabIntersection column="e2" row="e1"><style><CSS value="background-color:white;border:1pt solid silver"/><dataFormat><format pattern="####.##" whenAnyError="0" whenMissing="0" whenNotApplicable="0" whenSecurityError="0"/></dataFormat></style></crosstabIntersection></crosstabIntersections><conditionalRender refVariable="showSummary"><renderFor refVariableValue="1"/></conditionalRender></crosstab></contents><style><CSS value="vertical-align:bottom"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-top:20px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:5px;background-color:#F7F7F7;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Select Application(s): </staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px;padding-bottom:3px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<selectValue parameter="sApp" refQuery="Applications Prompt" required="false" multiSelect="true" selectValueUI="checkboxGroup"><useItem refDataItem="Application"/><style><CSS value="width:350px;height:650px;color:#454545"/></style><headerText><defaultText>Application Name</defaultText></headerText></selectValue></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		<promptButton type="next">
			<contents><textItem><dataSource><staticValue>Apply</staticValue></dataSource></textItem></contents>
			<style>
				<defaultStyles>
					<defaultStyle refStyle="bp"/>
				</defaultStyles>
			<CSS value="background-color:silver"/></style>
		</promptButton></contents><style><CSS value="text-align:center;padding-top:5px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:10px;background-color:#F7F7F7;padding-right:10px;padding-bottom:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.1.  2014-15 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							</page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.905Z"/></XMLAttributes><reportName>2.23 Application Capacity Changes and Growth</reportName><queries><query name="Base Capacity Trends">
			<source>
				
			<sqlQuery dataSource="dwh_capacity" name="SQL1">
			<sqlText>SELECT
trend.storage as 'Storage Name',
trend.datacenter as 'Data Center',
trend.model as 'Model',
trend.fulldate as 'Full Date',
trend.capacityTB as 'Usable (TB)',
trend.usedCapacityTB as 'Used (TB)',
begin.capacityTB as 'Beginning Usable (TB)',
begin.usedCapacityTB as 'Beginning Used (TB)',
end.capacityTB as 'Current Usable (TB)',
end.usedCapacityTB as 'Current Used (TB)'


FROM (

SELECT 	
	dwh_capacity.storage_dimension.datacenter as datacenter,
	dwh_capacity.storage_dimension.name as storage,
	dwh_capacity.storage_dimension.model as model,
	dwh_capacity.storage_dimension.tk as storagetk,
	dwh_capacity.date_dimension.fulldate as fulldate,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawcapacityMB)/1024/1024, 2) AS rawCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS capacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS usedCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB)/1024/1024, 2) AS provisionedCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeConsumedCapacityMB)/1024/1024, 2) AS volumeConsumedTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB)/1024/1024, 2) AS internalVolumeAllocatedTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeConsumedCapacityMB)/1024/1024, 2) AS internalVolumeConsumedTB
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
AND 	dwh_capacity.storage_and_storage_pool_capacity_fact.isVirtual = 0
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND	dwh_capacity.date_dimension.repmonthorlatest=1

WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 365 DAY

GROUP BY
	dwh_capacity.storage_dimension.name, dwh_capacity.date_dimension.fulldate

) trend

LEFT JOIN

( SELECT 	
	dwh_capacity.storage_dimension.name as storage,
	dwh_capacity.storage_dimension.tk as storagetk,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawcapacityMB)/1024/1024, 2) AS rawCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS capacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS usedCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB)/1024/1024, 2) AS provisionedCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeConsumedCapacityMB)/1024/1024, 2) AS volumeConsumedTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB)/1024/1024, 2) AS internalVolumeAllocatedTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeConsumedCapacityMB)/1024/1024, 2) AS internalVolumeConsumedTB,
	dwh_capacity.date_dimension.fulldate
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
AND 	dwh_capacity.storage_and_storage_pool_capacity_fact.isVirtual = 0
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND	dwh_capacity.date_dimension.repmonthorlatest=1

WHERE dwh_capacity.date_dimension.fullDate BETWEEN 

(SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 365 DAY 

AND

(SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 335 DAY 



GROUP BY
	dwh_capacity.storage_dimension.name

) begin ON begin.storagetk=trend.storagetk


LEFT JOIN

( SELECT 	
	dwh_capacity.storage_dimension.name as storage,
	dwh_capacity.storage_dimension.tk as storagetk,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawcapacityMB)/1024/1024, 2) AS rawCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS capacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS usedCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB)/1024/1024, 2) AS provisionedCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeConsumedCapacityMB)/1024/1024, 2) AS volumeConsumedTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB)/1024/1024, 2) AS internalVolumeAllocatedTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeConsumedCapacityMB)/1024/1024, 2) AS internalVolumeConsumedTB
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
AND 	dwh_capacity.storage_and_storage_pool_capacity_fact.isVirtual = 0
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND	dwh_capacity.date_dimension.repmonthorlatest=1

WHERE dwh_capacity.date_dimension.fullDate = (SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY

GROUP BY
	dwh_capacity.storage_dimension.name

) end ON end.storagetk=trend.storagetk


</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Data Center"/><mdProjectedItem name="Model"/><mdProjectedItem name="Full Date"/><mdProjectedItem name="Usable (TB)"/><mdProjectedItem name="Used (TB)"/><mdProjectedItem name="Beginning Usable (TB)"/><mdProjectedItem name="Beginning Used (TB)"/><mdProjectedItem name="Current Usable (TB)"/><mdProjectedItem name="Current Used (TB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Data Center"><expression>[SQL1].[Data Center]</expression></dataItem><dataItem name="Storage Name" rollupAggregate="none"><expression>[SQL1].[Storage Name]</expression></dataItem><dataItem name="Model"><expression>[SQL1].[Model]</expression></dataItem><dataItem name="Full Date"><expression>[SQL1].[Full Date]</expression></dataItem><dataItem name="Usable (TB)"><expression>[SQL1].[Usable (TB)]</expression></dataItem><dataItem aggregate="maximum" name="Used (TB)"><expression>[SQL1].[Used (TB)]</expression></dataItem><dataItem name="Beginning Usable (TB)"><expression>[SQL1].[Beginning Usable (TB)]</expression></dataItem><dataItem aggregate="maximum" name="Beginning Used (TB)"><expression>[SQL1].[Beginning Used (TB)]</expression></dataItem><dataItem name="Current Usable (TB)"><expression>[SQL1].[Current Usable (TB)]</expression></dataItem><dataItem aggregate="maximum" name="Current Used (TB)"><expression>[SQL1].[Current Used (TB)]</expression></dataItem><dataItem name="Diff +/-"><expression>if(running-difference([Used (TB)] for [Storage Name]) is null) THEN (0) ELSE (running-difference([Used (TB)] for [Storage Name]))</expression></dataItem><dataItem name="Average Growth Rate"><expression>([Current Used (TB)]-[Beginning Used (TB)])/12</expression></dataItem></selection>
		</query><query name="Report">
			<source>
				
			<sqlQuery dataSource="dwh_capacity" name="SQL2">
			<sqlText>SELECT
trend.storage as 'Storage Name',
trend.model as 'Model',
trend.fulldate as 'Full Date',
trend.capacityTB as 'Usable (TB)',
trend.usedCapacityTB as 'Used (TB)',
IF(begin.capacityTB is null, 0, begin.capacityTB) as 'Beginning Usable (TB)',
IF(begin.usedCapacityTB is null, 0, begin.usedCapacityTB) as 'Beginning Used (TB)',
IF(end.capacityTB is null, 0, end.capacityTB) as 'Current Usable (TB)',
IF(end.usedCapacityTB is null, 0, end.usedCapacityTB ) as 'Current Used (TB)'


FROM (

SELECT 	
	IF(dwh_capacity.storage_dimension.manufacturer='netapp', SUBSTRING_INDEX(dwh_capacity.storage_pool_dimension.name,':',1), dwh_capacity.storage_dimension.name) as storage,
	

	dwh_capacity.storage_dimension.model as model,
	dwh_capacity.storage_dimension.tk as storagetk,
	dwh_capacity.date_dimension.fulldate as fulldate,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawcapacityMB)/1024/1024, 2) AS rawCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS capacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS usedCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB)/1024/1024, 2) AS provisionedCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeConsumedCapacityMB)/1024/1024, 2) AS volumeConsumedTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB)/1024/1024, 2) AS internalVolumeAllocatedTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeConsumedCapacityMB)/1024/1024, 2) AS internalVolumeConsumedTB
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
AND 	dwh_capacity.storage_and_storage_pool_capacity_fact.isVirtual = 0
AND	dwh_capacity.storage_dimension.datacenter&lt;&gt;'N/A'
JOIN	dwh_capacity.storage_pool_dimension
ON	dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk

JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND	dwh_capacity.date_dimension.repmonthorlatest=1

WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 365 DAY

GROUP BY
	storage, dwh_capacity.date_dimension.fulldate

) trend

LEFT JOIN

( SELECT 	
	IF(dwh_capacity.storage_dimension.manufacturer='netapp', SUBSTRING_INDEX(dwh_capacity.storage_pool_dimension.name,':',1), dwh_capacity.storage_dimension.name) as storage,
	
	dwh_capacity.storage_dimension.tk as storagetk,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawcapacityMB)/1024/1024, 2) AS rawCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS capacityTB,
	ROUND(MAX(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS usedCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB)/1024/1024, 2) AS provisionedCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeConsumedCapacityMB)/1024/1024, 2) AS volumeConsumedTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB)/1024/1024, 2) AS internalVolumeAllocatedTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeConsumedCapacityMB)/1024/1024, 2) AS internalVolumeConsumedTB,
	dwh_capacity.date_dimension.fulldate
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
AND 	dwh_capacity.storage_and_storage_pool_capacity_fact.isVirtual = 0
AND	dwh_capacity.storage_dimension.datacenter&lt;&gt;'N/A'
JOIN	dwh_capacity.storage_pool_dimension
ON	dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk

JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND	dwh_capacity.date_dimension.repmonthorlatest=1

WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MIN(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension)
AND dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 365 DAY

GROUP BY
	storage

) begin ON begin.storagetk=trend.storagetk


LEFT JOIN

( SELECT 	
IF(dwh_capacity.storage_dimension.manufacturer='netapp', SUBSTRING_INDEX(dwh_capacity.storage_pool_dimension.name,':',1), dwh_capacity.storage_dimension.name) as storage,
	dwh_capacity.storage_dimension.tk as storagetk,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawcapacityMB)/1024/1024, 2) AS rawCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS capacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS usedCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB)/1024/1024, 2) AS provisionedCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeConsumedCapacityMB)/1024/1024, 2) AS volumeConsumedTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB)/1024/1024, 2) AS internalVolumeAllocatedTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeConsumedCapacityMB)/1024/1024, 2) AS internalVolumeConsumedTB
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
AND 	dwh_capacity.storage_and_storage_pool_capacity_fact.isVirtual = 0
JOIN	dwh_capacity.storage_pool_dimension
ON	dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk

JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND	dwh_capacity.date_dimension.repmonthorlatest=1

WHERE dwh_capacity.date_dimension.fullDate = (SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY

GROUP BY
	storage

) end ON end.storagetk=trend.storagetk


</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Model"/><mdProjectedItem name="Full Date"/><mdProjectedItem name="Usable (TB)"/><mdProjectedItem name="Used (TB)"/><mdProjectedItem name="Beginning Usable (TB)"/><mdProjectedItem name="Beginning Used (TB)"/><mdProjectedItem name="Current Usable (TB)"/><mdProjectedItem name="Current Used (TB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL2].[Storage Name]</expression></dataItem><dataItem name="Model"><expression>[SQL2].[Model]</expression></dataItem><dataItem name="Full Date"><expression>[SQL2].[Full Date]</expression></dataItem><dataItem name="Usable (TB)"><expression>[SQL2].[Usable (TB)]</expression></dataItem><dataItem name="Used (TB)"><expression>[SQL2].[Used (TB)]</expression></dataItem><dataItem name="Beginning Usable (TB)"><expression>[SQL2].[Beginning Usable (TB)]</expression></dataItem><dataItem aggregate="maximum" name="Beginning Used (TB)"><expression>[SQL2].[Beginning Used (TB)]</expression></dataItem><dataItem name="Current Usable (TB)"><expression>[SQL2].[Current Usable (TB)]</expression></dataItem><dataItem aggregate="maximum" name="Current Used (TB)"><expression>[SQL2].[Current Used (TB)]</expression></dataItem><dataItem name="Diff +/-"><expression>if(running-difference([Used (TB)] for [Storage Name]) is null) THEN (0) ELSE (running-difference([Used (TB)] for [Storage Name]))</expression></dataItem><dataItem name="Average Growth Rate"><expression>([Current Used (TB)]-[Beginning Used (TB)])/12</expression></dataItem></selection>
		</query><query name="Application">
			<source>
				
			<sqlQuery name="SQL3" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT
trend.Application as 'Storage Name',
trend.FullDate as 'Full Date',
trend.UsedTB as 'Used (TB)',
IF(begin.usedCapacityTB is null, 0, begin.usedCapacityTB) as 'Beginning Used (TB)',
IF(end.usedCapacityTB is null, 0, end.usedCapacityTB ) as 'Current Used (TB)'


FROM

(
SELECT
dwh_capacity.application_dimension.name as 'Application',
dwh_capacity.application_dimension.tk as apptk,
ROUND(SUM(dwh_capacity.chargeback_fact.usedCapacityMB)/1024/1024,2) as ' UsedTB',
dwh_capacity.date_dimension.fulldate as 'FullDate'

FROM dwh_capacity.chargeback_fact
JOIN dwh_capacity.application_dimension
ON   dwh_capacity.application_dimension.tk=dwh_capacity.chargeback_fact.applicationtk
AND  dwh_capacity.application_dimension.name &lt;&gt; 'N/A'
JOIN dwh_capacity.date_dimension
ON   dwh_capacity.date_dimension.tk=dwh_capacity.chargeback_fact.datetk
AND  dwh_capacity.date_dimension.repmonthorlatest=1

-- DATE_FORMAT("2017-06-15", "%M %d %Y"); 

WHERE dwh_capacity.date_dimension.fullDate  &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
FROM dwh_capacity.date_dimension JOIN  dwh_capacity.chargeback_fact 
ON  dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 365 DAY

GROUP BY dwh_capacity.application_dimension.tk, dwh_capacity.date_dimension.tk) trend

LEFT JOIN

(
SELECT

dwh_capacity.application_dimension.tk as endapptk,
ROUND(SUM(dwh_capacity.chargeback_fact.usedCapacityMB)/1024/1024,2) as 'usedCapacityTB',
dwh_capacity.date_dimension.fulldate as 'EndDate'

FROM dwh_capacity.chargeback_fact
JOIN dwh_capacity.application_dimension
ON   dwh_capacity.application_dimension.tk=dwh_capacity.chargeback_fact.applicationtk
AND  dwh_capacity.application_dimension.name &lt;&gt; 'N/A'
JOIN dwh_capacity.date_dimension
ON   dwh_capacity.date_dimension.tk=dwh_capacity.chargeback_fact.datetk


WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
FROM dwh_capacity.date_dimension JOIN  dwh_capacity.chargeback_fact 
ON  dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY

GROUP BY dwh_capacity.application_dimension.tk) end ON end.endapptk=trend.apptk

LEFT JOIN


(
SELECT

dwh_capacity.application_dimension.tk as beginapptk,
ROUND(dwh_capacity.chargeback_fact.usedCapacityMB/1024/1024,2) as 'usedCapacityTB',
dwh_capacity.date_dimension.fulldate as 'BeginDate'

FROM dwh_capacity.chargeback_fact
JOIN dwh_capacity.application_dimension
ON   dwh_capacity.application_dimension.tk=dwh_capacity.chargeback_fact.applicationtk
JOIN dwh_capacity.date_dimension
ON   dwh_capacity.date_dimension.tk=dwh_capacity.chargeback_fact.datetk

WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MIN(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension)
AND dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 365 DAY


GROUP BY dwh_capacity.application_dimension.tk) begin ON begin.beginapptk=trend.apptk



</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Full Date"/><mdProjectedItem name="Used (TB)"/><mdProjectedItem name="Beginning Used (TB)"/><mdProjectedItem name="Current Used (TB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL3].[Storage Name]</expression></dataItem><dataItem name="Full Date"><expression>[SQL3].[Full Date]</expression></dataItem><dataItem name="Used (TB)"><expression>[SQL3].[Used (TB)]</expression></dataItem><dataItem name="Beginning Used (TB)" aggregate="maximum"><expression>[SQL3].[Beginning Used (TB)]</expression></dataItem><dataItem name="Current Used (TB)" aggregate="maximum"><expression>[SQL3].[Current Used (TB)]</expression></dataItem><dataItem name="Diff +/-"><expression>if(running-difference([Used (TB)] for [Storage Name]) is null) THEN (0) ELSE (running-difference([Used (TB)] for [Storage Name]))</expression></dataItem><dataItem name="Average Growth Rate"><expression>([Current Used (TB)]-[Beginning Used (TB)])/12</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[Storage Name] in ?sApp?</filterExpression></detailFilter></detailFilters></query><query name="Chart">
			<source>
				
			<queryRef refQuery="Application"/></source>
			<selection><dataItem name="Storage Name"><expression>[Application].[Storage Name]</expression></dataItem><dataItem name="Full Date"><expression>[Application].[Full Date]</expression></dataItem><dataItem name="Used (TB)"><expression>[Application].[Used (TB)]</expression></dataItem><dataItem name="Beginning Used (TB)"><expression>[Application].[Beginning Used (TB)]</expression></dataItem><dataItem name="Current Used (TB)"><expression>[Application].[Current Used (TB)]</expression></dataItem><dataItem name="Diff +/-"><expression>[Application].[Diff +/-]</expression></dataItem><dataItem name="Average Growth Rate" aggregate="total"><expression>[Application].[Average Growth Rate]</expression></dataItem></selection>
		<detailFilters><detailFilter><filterExpression>[Average Growth Rate]&gt;0</filterExpression></detailFilter></detailFilters></query><query name="Application Summary">
			<source>
				
			<sqlQuery name="SQL5" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT
trend.Application as 'Storage Name',
trend.FullDate as 'Full Date',
trend.UsedTB as 'Used (TB)',
IF(begin.usedCapacityTB is null, 0, begin.usedCapacityTB) as 'Beginning Used (TB)',
IF(end.usedCapacityTB is null, 0, end.usedCapacityTB ) as 'Current Used (TB)'


FROM

(
SELECT
dwh_capacity.application_dimension.name as 'Application',
dwh_capacity.application_dimension.tk as apptk,
ROUND(SUM(dwh_capacity.chargeback_fact.usedCapacityMB)/1024/1024,2) as ' UsedTB',
dwh_capacity.date_dimension.fulldate as 'FullDate'

FROM dwh_capacity.chargeback_fact
JOIN dwh_capacity.application_dimension
ON   dwh_capacity.application_dimension.tk=dwh_capacity.chargeback_fact.applicationtk
AND  dwh_capacity.application_dimension.name &lt;&gt; 'N/A'
JOIN dwh_capacity.date_dimension
ON   dwh_capacity.date_dimension.tk=dwh_capacity.chargeback_fact.datetk
AND  dwh_capacity.date_dimension.repmonthorlatest=1

-- DATE_FORMAT("2017-06-15", "%M %d %Y"); 

WHERE dwh_capacity.date_dimension.fullDate  &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
FROM dwh_capacity.date_dimension JOIN  dwh_capacity.chargeback_fact 
ON  dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 365 DAY

GROUP BY dwh_capacity.application_dimension.tk, dwh_capacity.date_dimension.tk) trend

LEFT JOIN

(
SELECT

dwh_capacity.application_dimension.tk as endapptk,
ROUND(SUM(dwh_capacity.chargeback_fact.usedCapacityMB)/1024/1024,2) as 'usedCapacityTB',
dwh_capacity.date_dimension.fulldate as 'EndDate'

FROM dwh_capacity.chargeback_fact
JOIN dwh_capacity.application_dimension
ON   dwh_capacity.application_dimension.tk=dwh_capacity.chargeback_fact.applicationtk
AND  dwh_capacity.application_dimension.name &lt;&gt; 'N/A'
JOIN dwh_capacity.date_dimension
ON   dwh_capacity.date_dimension.tk=dwh_capacity.chargeback_fact.datetk


WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
FROM dwh_capacity.date_dimension JOIN  dwh_capacity.chargeback_fact 
ON  dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY

GROUP BY dwh_capacity.application_dimension.tk) end ON end.endapptk=trend.apptk

LEFT JOIN


(
SELECT

dwh_capacity.application_dimension.tk as beginapptk,
ROUND(dwh_capacity.chargeback_fact.usedCapacityMB/1024/1024,2) as 'usedCapacityTB',
dwh_capacity.date_dimension.fulldate as 'BeginDate'

FROM dwh_capacity.chargeback_fact
JOIN dwh_capacity.application_dimension
ON   dwh_capacity.application_dimension.tk=dwh_capacity.chargeback_fact.applicationtk
JOIN dwh_capacity.date_dimension
ON   dwh_capacity.date_dimension.tk=dwh_capacity.chargeback_fact.datetk

WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MIN(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension)
AND dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 365 DAY


GROUP BY dwh_capacity.application_dimension.tk) begin ON begin.beginapptk=trend.apptk



</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Full Date"/><mdProjectedItem name="Used (TB)"/><mdProjectedItem name="Beginning Used (TB)"/><mdProjectedItem name="Current Used (TB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL5].[Storage Name]</expression></dataItem><dataItem name="Full Date"><expression>[SQL5].[Full Date]</expression></dataItem><dataItem name="Used (TB)"><expression>[SQL5].[Used (TB)]</expression></dataItem><dataItem name="Beginning Used (TB)" aggregate="maximum"><expression>[SQL5].[Beginning Used (TB)]</expression></dataItem><dataItem name="Current Used (TB)" aggregate="maximum"><expression>[SQL5].[Current Used (TB)]</expression></dataItem><dataItem name="Diff +/-" aggregate="total"><expression>if(running-difference([Used (TB)] for Report) is null) THEN (0) ELSE (running-difference([Used (TB)] for Report))</expression></dataItem><dataItem name="Average Growth Rate"><expression>([Current Used (TB)]-[Beginning Used (TB)])/12</expression></dataItem><dataItemEdgeSummary solveOrder="1" refDataItem="Storage Name" aggregateMethod="total" name="Total(Storage Name)" label="Total"/><dataItemEdgeSummary solveOrder="1" refDataItem="Storage Name" aggregateMethod="total" name="Total(Storage Name)1" label="Summary"/><dataItemEdgeSummary solveOrder="1" refDataItem="Storage Name" aggregateMethod="total" name="Total(Storage Name)2" label="Total"/></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[Storage Name] in ?sApp?</filterExpression></detailFilter></detailFilters></query><query name="Applications Prompt">
			<source>
				
			<sqlQuery name="SQL4" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT
dwh_inventory.application.name as 'Application'

FROM dwh_inventory.application
WHERE dwh_inventory.application.name &lt;&gt; 'N/A'

ORDER BY dwh_inventory.application.name</sqlText>
		<mdProjectedItems><mdProjectedItem name="Application"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Application"><expression>[SQL4].[Application]</expression></dataItem></selection>
		</query></queries><namedConditionalStyles><advancedConditionalStyle name="Conditional Style 2"><styleCases><styleCase><style><CSS value="color:red"/></style><reportCondition>[Application].[Diff +/-]&lt;0</reportCondition></styleCase><styleCase><style><CSS value="color:green"/></style><reportCondition>[Application].[Diff +/-]&gt;0</reportCondition></styleCase></styleCases><styleDefault/></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 1"><styleCases><styleCase><style><CSS value="color:red"/></style><reportCondition>[Application Summary].[Diff +/-]&lt;0</reportCondition></styleCase><styleCase><style><CSS value="color:green"/></style><reportCondition>[Application Summary].[Diff +/-]&gt;0</reportCondition></styleCase></styleCases><styleDefault/></advancedConditionalStyle></namedConditionalStyles><reportVariables><reportVariable type="boolean" name="showGrowthChart">
			<reportExpression>ParamDisplayValue('sApp') is null</reportExpression>
			<variableValues>
				<variableValue value="1"/>
			</variableValues>
		</reportVariable><reportVariable type="boolean" name="showSummary">
			<reportExpression>ParamDisplayValue('sApp') is not null</reportExpression>
			<variableValues>
				<variableValue value="1"/>
			</variableValues>
		</reportVariable><reportVariable type="boolean" name="hidePrimary">
			<reportExpression>ParamDisplayValue('sApp') is null</reportExpression>
			<variableValues>
				<variableValue value="1"/>
			</variableValues>
		</reportVariable></reportVariables></report>